Page History: CAREWare 6 SQL Server Import
Compare Page Revisions
Page Revision: Thu, 20 Jun 2019 10:04
CAREWare includes options to import data in several formats including importing from a SQL Server Database. When using the SQL Server Import option, CAREWare creates a database called cw_pdi in the CAREWare database instance. The cw_pdi database uses the same
pdi specifications as the
Template.mdb file located in the RW CAREWare Business Tier folder. Once the SQL Server Import is enabled, the cw_pdi database is created and ready for importing or exporting data using SQL.
Follow these steps to enable SQL Server Imports:
- Log into Central Administration.
- Click Administrative Options.
- Click Data Import and Export Features.
- Click Provider Data Import.
- Click SQL Server Import.
- Check Enable PDI SQL Server Import.
- Click Save.
SQL Server Imports are scheduled tasks. To begin importing data from the cw_pdi database, the import process needs to be scheduled.
8. Enter the
Scheduled Time (HH:mm).
9. Set the frequency by selecting the
Scheduled Day.
Additional options include using custom field templates. To import custom field records, those custom fields need to be saved as a template in CAREWare and those custom field columns need to be added to the cw_pdi database to match the template.
Each of these templates listed under Custom Field Template (optional) are saved under Custom Field Templates.
To add a Custom Field Template to the list follow the steps
here.
SQL Server Imports include an option to email users error message that occur during the import.
To prompt users for import errors check Email on Error.
To download these instructions click
here.
Back to
CAREWare 6 and CAREWare 5 Program Administrator FAQ